package com.edu.app.mapper.customize;

import com.edu.app.bean.core.customize.SysCustomerExtensionYlyn;
import com.edu.app.util.AppBaseMapper;

import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

@Component
public interface SysCustomerExtensionYlynMapper extends AppBaseMapper<SysCustomerExtensionYlyn> {
    @Select("SELECT * FROM S_CUSTOMER_EX_YLYN WHERE CUSTOMER_ID=#{customer_id}")
    SysCustomerExtensionYlyn getCustomerDetailsByCustomerId(Integer customer_id);

    @Select("DELETE FROM S_CUSTOMER_EX_YLYN WHERE CUSTOMER_ID=#{customer_id}")
    SysCustomerExtensionYlyn deleteCustomerDetailsByCustomerId(Integer customer_id);
}
